db schema compare

From: Ed King 
------------------------------------------------------
Specifically,  for postgresql

Yeah, I know I can Google and get a list of tools, but I want to know which
one(s) YOU, my fellow chuggers, like.to use

I've tried pg_admin's compare tool,  and I've seen an aquadata studio demo.

I have written bash scripts that call psql to:
identify diffs
drop dependencies
alter the tables and/or views
restore tables/views/grants/indexes

so I do have a solution, but I was wondering if there is a tool with a nice
gui that can do all of that.

===============================================================
From: Dan Danese 
------------------------------------------------------
For postgres DBs, the favored tool now is dBeaver. I admin numerous types
of postgres based databases and this is the primary tool of the user base
now.

-br
Dan

On Fri, Jul 7, 2023 at 8:15=E2=80=AFAM Ed King 
wrote:



===============================================================
From: Ed King 
------------------------------------------------------
Thanks Dan..    I've used DBeaver but what I'm looking for is a tool that
can do fully automated db sync...     which might be a pipe dream.

A tool that can not only identify db "diffs" but also be intelligent enough
to perform the sync, even if it means dropping/restoring  umpteen dependent
views

I've written bash+psql scripts to do db sync but they are tedious